Estimated Equation

## [1] "LnTrendedPrice = 6.08514859421406 + 0.292299138797382 * BaseLandC + 0.331221399903332 * TotalRcnC - 0.0978292792914997 * AgeC_Ren + 0.0306832003659105 * GoodYN + 0.110260453251257 * VGoodYN"

Descriptive Statistics

Variable Count Mean Std. Dev. Std. Error Min Max
LnTrendedPrice 1101 13.87328 0.29770 0.00897 11.74077 14.95086
BaseLandC 1101 12.94630 0.13412 0.00404 12.35879 14.37284
TotalRcnC 1101 12.89035 0.42157 0.01270 11.82774 14.52108
AgeC_Ren 1101 2.85647 0.98734 0.02976 1.09861 4.49981
GoodYN 1101 0.28429 0.45128 0.01360 0.00000 1.00000
VGoodYN 1101 0.04632 0.21028 0.00634 0.00000 1.00000

Run Summary Report

Dependent Variable LnTrendedPrice
Number of Independent Variables 5
R Squared 0.4205255
Adjusted R-Squared 0.4178795
Residual Standard Error 0.2271343

Correlation Matrix


Coefficients T-Tests and Confidence Intervals

Variables Regression Coefficient Std. Error T-Statistic to Test (H0) Prob Level Reject H0 at 5%? Lower 95% Confidence Limit Upper 95% Confidence Limit
(Intercept) 6.08514859 0.68896870 8.832257 0.00000000 Yes 4.73330051 7.43699668
BaseLandC 0.29229914 0.05171331 5.652300 0.00000002 Yes 0.19083076 0.39376752
TotalRcnC 0.33122140 0.01843097 17.970912 0.00000000 Yes 0.29505738 0.36738542
AgeC_Ren -0.09782928 0.00947144 -10.328873 0.00000000 Yes -0.11641350 -0.07924506
GoodYN 0.03068320 0.01978612 1.550744 0.12125210 No -0.00813980 0.06950620
VGoodYN 0.11026045 0.03603025 3.060219 0.00226559 Yes 0.03956431 0.18095660

Analysis of Variance Detail (ANOVA)

Variables Df Sum of Squares Mean Sq F value Prob Level
BaseLandC 1 1.45201 1.45201 28.14515 0.00000
TotalRcnC 1 32.65902 32.65902 633.04968 0.00000
AgeC_Ren 1 6.38822 6.38822 123.82668 0.00000
GoodYN 1 0.01324 0.01324 0.25655 0.61260
VGoodYN 1 0.48314 0.48314 9.36494 0.00227
Error 1095 56.49103 0.05159 NA NA

R-Squared Report

Independent Variable (I.V.) Stepwise R-Squared Stepwise Mallow’s Cp Stepwise RMSE
TotalRcnC 0.34123 147.83329 0.24173
AgeC_Ren 0.39916 40.37896 0.23097
BaseLandC 0.41543 11.62149 0.22792
VGoodYN 0.41925 6.40481 0.22728
GoodYN 0.42053 6.00000 0.22713

Variable Omission Report

Variable R-Sq if I.V. Omitted Mallow’s Cp if I.V. Omitted
BaseLandC 0.40362 35.94850
TotalRcnC 0.24962 326.95367
AgeC_Ren 0.36407 110.68562
GoodYN 0.41925 6.40481
VGoodYN 0.41557 13.36494

Multicollinearity Table

Variables Tolerance Variance Inflation Factor (VIF)
BaseLandC 0.9749181 1.025727
TotalRcnC 0.7768562 1.287240
AgeC_Ren 0.5362976 1.864636
GoodYN 0.5882485 1.699962
VGoodYN 0.8170687 1.223887

Histogram and QQ-Plots


Normality Output

Test Name Test Statistic Prob Level
Shapiro-Wilk normality test 0.84437 0
Anderson - Darling Normality Test 28.68604 0
D’Agostino Chi-Squared Test 674.02457 0
D’Agostino Skewness Test -19.59936 0
D’AGostino Kurtosis Test 17.02615 0

Residual of Y vs Predicted Y


Residual of Y vs Sale Price


Fitted Y vs Fitted X Plots


Component + Residual Plots